﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="SGTDdsReporte2" targetNamespace="http://tempuri.org/SGTDdsReporte2.xsd" xmlns:mstns="http://tempuri.org/SGTDdsReporte2.xsd" xmlns="http://tempuri.org/SGTDdsReporte2.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="conexion" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="conexion (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.SGTD.Properties.Settings.GlobalReference.Default.conexion" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="FichaTDoc_reporte_PATableAdapter" GeneratorDataComponentClassName="FichaTDoc_reporte_PATableAdapter" Name="FichaTDoc_reporte_PA" UserDataComponentName="FichaTDoc_reporte_PATableAdapter">
            <MainSource>
              <DbSource ConnectionRef="conexion (Settings)" DbObjectName="SGTD.dbo.FichaTDoc_reporte_PA" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.FichaTDoc_reporte_PA</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idarea" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@fechaini" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@fechafin" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nchar" DbType="StringFixedLength" Direction="Input" ParameterName="@estado" Precision="0" ProviderType="NChar" Scale="0" Size="20" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@opc" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IdFichaTramite" DataSetColumn="IdFichaTramite" />
              <Mapping SourceColumn="IdDocumento" DataSetColumn="IdDocumento" />
              <Mapping SourceColumn="fechacarga" DataSetColumn="fechacarga" />
              <Mapping SourceColumn="EstadoEntrega" DataSetColumn="EstadoEntrega" />
              <Mapping SourceColumn="Asunto" DataSetColumn="Asunto" />
              <Mapping SourceColumn="NombreArea" DataSetColumn="NombreArea" />
              <Mapping SourceColumn="Estado" DataSetColumn="Estado" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="SGTDdsReporte2" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="SGTDdsReporte2" msprop:Generator_UserDSName="SGTDdsReporte2">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="FichaTDoc_reporte_PA" msprop:Generator_TableClassName="FichaTDoc_reporte_PADataTable" msprop:Generator_TableVarName="tableFichaTDoc_reporte_PA" msprop:Generator_TablePropName="FichaTDoc_reporte_PA" msprop:Generator_RowDeletingName="FichaTDoc_reporte_PARowDeleting" msprop:Generator_UserTableName="FichaTDoc_reporte_PA" msprop:Generator_RowChangingName="FichaTDoc_reporte_PARowChanging" msprop:Generator_RowEvHandlerName="FichaTDoc_reporte_PARowChangeEventHandler" msprop:Generator_RowDeletedName="FichaTDoc_reporte_PARowDeleted" msprop:Generator_RowEvArgName="FichaTDoc_reporte_PARowChangeEvent" msprop:Generator_RowChangedName="FichaTDoc_reporte_PARowChanged" msprop:Generator_RowClassName="FichaTDoc_reporte_PARow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IdFichaTramite" msprop:Generator_ColumnVarNameInTable="columnIdFichaTramite" msprop:Generator_ColumnPropNameInRow="IdFichaTramite" msprop:Generator_ColumnPropNameInTable="IdFichaTramiteColumn" msprop:Generator_UserColumnName="IdFichaTramite" type="xs:int" minOccurs="0" />
              <xs:element name="IdDocumento" msprop:Generator_ColumnVarNameInTable="columnIdDocumento" msprop:Generator_ColumnPropNameInRow="IdDocumento" msprop:Generator_ColumnPropNameInTable="IdDocumentoColumn" msprop:Generator_UserColumnName="IdDocumento" type="xs:int" minOccurs="0" />
              <xs:element name="fechacarga" msprop:Generator_ColumnVarNameInTable="columnfechacarga" msprop:Generator_ColumnPropNameInRow="fechacarga" msprop:Generator_ColumnPropNameInTable="fechacargaColumn" msprop:Generator_UserColumnName="fechacarga" type="xs:dateTime" minOccurs="0" />
              <xs:element name="EstadoEntrega" msprop:Generator_ColumnVarNameInTable="columnEstadoEntrega" msprop:Generator_ColumnPropNameInRow="EstadoEntrega" msprop:Generator_ColumnPropNameInTable="EstadoEntregaColumn" msprop:Generator_UserColumnName="EstadoEntrega" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Asunto" msprop:Generator_ColumnVarNameInTable="columnAsunto" msprop:Generator_ColumnPropNameInRow="Asunto" msprop:Generator_ColumnPropNameInTable="AsuntoColumn" msprop:Generator_UserColumnName="Asunto" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NombreArea" msprop:Generator_ColumnVarNameInTable="columnNombreArea" msprop:Generator_ColumnPropNameInRow="NombreArea" msprop:Generator_ColumnPropNameInTable="NombreAreaColumn" msprop:Generator_UserColumnName="NombreArea">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Estado" msprop:Generator_ColumnVarNameInTable="columnEstado" msprop:Generator_ColumnPropNameInRow="Estado" msprop:Generator_ColumnPropNameInTable="EstadoColumn" msprop:Generator_UserColumnName="Estado">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
  </xs:element>
</xs:schema>